package com.vlin.mapper.family;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.vlin.entity.room.Room;

public interface RoomMapper {

	@Insert("insert into room(fid,name) values(#{fid},#{name})")
	public int addRoom(Room room);
	
	//@Update
	//public int updateRoom();
	
	@Delete("delete from family where fid=#{fid}")
	public int deleteRoom(@Param("rid") int rid);
	
	//根据fid查询rid
	@Select("select fid,name,rid from room where fid=#{fid}")
	public List<Room> getListRoom(@Param("fid") int fid);
	
	
	
}
